Beginning Power BI for Business Users by Paul D. Fuller

Author:Paul D. Fuller [Fuller, Paul D.]
Language: eng
Format: epub
ISBN: 9781394190300
Publisher: Wiley
Published: 2023-10-31T00:00:00+00:00

In our case, we already have a column that calculates the numerator and a field for the denominator. So, let's implement that in a DAX calculated column!

DIVIDE Function

Before we do that, recall that zero divided by anything is zero. However, nothing can be divided by zero. In fact, in Excel if you try to divide by zero, you get the infamous #DIV/0! error. The DAX language provides a nice way to handle division by zero without generating an error. While you could just use the division operation (/), the DIVIDE function is designed to not throw an error when division by zero happens. Add a new column and use this formula to calculate our percentage change.

Change % = DIVIDE ( 'GDP'[Change], 'GDP'[Value] )

The resulting values in the new Change % column are all decimals. So, click the Column Tools ribbon and click the Percent button in the Formatting section. Now the Change % column displays the values as percentages. I left the default number of decimal places as two, but you can adjust that too if you'd like (see Figure 5.13).

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.